<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <!-- InstanceBegin template="/Templates/anydbtest.dwt" codeOutsideHTMLIsLocked="false" -->
    <!-- InstanceBeginEditable name="doctitle" -->
    <title>Quick start for AnyDbTest</title>
    <!-- InstanceEndEditable -->
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
    <meta name="AnyDbTest" content="AnyDbTest Technology">
     
    <meta name="robots" content="index,follow">
    <meta name="generator" content="AnyDbTest">
    <meta name="author" content="AnyDbTest Technology">
    <meta name="rating" content="General">
    <meta name="revisit-after" content="2 days">
    <meta name="classification" content="Science &amp; Technology">
    <meta name="distribution" content="Global">
    <link rel="stylesheet" type="text/css" href="style.css">
    <!-- InstanceBeginEditable name="head" -->
    <meta name="keywords" content="AnyDbTest, UnitTest, Database UnitTest, DB UnitTest, Database automatic test,  Unit test, Database Unit test, DB Unit test, DB automatic test - AnyDbTest Technology">
    <meta name="description" content="AnyDbTest Technology is devoted to developing intuitive, easy-to-use application and database software products for different categories of users. ">
    <!-- InstanceEndEditable -->

    <script type="text/JavaScript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
    </script>

    <link rel="stylesheet" type="text/css" href="csharp.css">
</head>
<body>
    <table width="960" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
            <td colspan="3">
                <img src="images/logo.png" width="960" height="87" border="0" usemap="#Map" onclick="MM_preloadImages('images/logo.png')" />
            </td>
        </tr>
        <tr>
            <td width="9" background="images/layout/site-left.gif">
                &nbsp;
            </td>
            <td width="942" height="37" background="images/layout/menu-bg.gif" onfocus="MM_preloadImages('images/layout/menu-bg.gif')">
                <table border="0" cellpadding="0" cellspacing="0">
                    <tbody>
                        <tr>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="index.html">Home</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="product.html">Product</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="download.html">Download</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="purchase.html">Purchase</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="support.html">Support</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="tutorial.html">Tutorial</a></div>
                            </td>
                            <!--
            <td class="MenuTop" width="120">
            <div align="center"><a href="affiliate.html">Affiliate</a></div>
            </td>
            -->
                        </tr>
                    </tbody>
                </table>
            </td>
            <td width="10" background="images/layout/site-right.gif">
                &nbsp;
            </td>
        </tr>
            <tr>
                <td colspan="3" background="images/layout/site-bg.gif">
                    <table border="0" cellpadding="0" cellspacing="0" width="960">
                        <tbody>
                            <tr>
                                <td height="50" width="9">
                                    &nbsp;
                                </td>
                                <td  class="productText" bgcolor="#ffffff" valign="top" width="716">
                                    <div class="LeftColumnPadding">
                                        <!-- InstanceBeginEditable name="LeftRegion" -->
                                        <table border="0" cellpadding="0" cellspacing="0" width="100%">
                                            <tbody>
                                                <tr>
                                                    <td>
                                                       
                                           <p align="justify">
                                                <h2>Quickstart<a name="TutorialQuickstart" id="TutorialQuickstart"></a></h2>
                                                
                                                In this example, we will use <strong>SQL Server 2005 </strong>as our database server. If you have not yet, you can get Express edition(free of charge) from Microsoft, please click<a href="http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en"> here </a>. 
                                                we will also use <strong> AdvantureWorks </strong>sample database shipped with SQL Server 2005. If you have no this sample database yet,
                                                click <a href="http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=4004#DownloadId=11753">here </a> to download on Microsoft CodePlex Site(or click <a href="download/AdventureWorksDB.msi">here</a> to download it from AnyDbTest) . 
                                                
                                                <br />
                                                <br />
                                                Suppose that we need to create two stored procedures to retrieve state/province information. Procedure usp_GetStatesInCountry is to fetch states in a specific country; another procedure usp_GetAllStates is to fetch all states in the database. T-SQL code listed below,
                                                <br />
<!-- code formatted by http://manoli.net/csharpformat/ -->
<pre class="csharpcode">
<span class="kwrd">USE</span> [AdventureWorks]
<span class="kwrd">GO</span>

/* Purpose: <span class="kwrd">To</span> <span class="kwrd">get</span> <span class="kwrd">all</span> <span class="kwrd">state</span> <span class="kwrd">in</span> this <span class="kwrd">database</span> */
<span class="kwrd">IF</span>  <span class="kwrd">EXISTS</span> (<span class="kwrd">SELECT</span> * <span class="kwrd">FROM</span> sys.objects <span class="kwrd">WHERE</span>
object_id = OBJECT_ID(N<span class="str">'[Person].[usp_GetAllStates]'</span>) <span class="kwrd">AND</span> type <span class="kwrd">in</span> (N<span class="str">'P'</span>, N<span class="str">'PC'</span>))
<span class="kwrd">DROP</span> <span class="kwrd">PROCEDURE</span> [Person].[usp_GetAllStates]
<span class="kwrd">GO</span>

<span class="kwrd">CREATE</span> <span class="kwrd">PROCEDURE</span> [Person].[usp_GetAllStates]
<span class="kwrd">AS</span>
<span class="kwrd">BEGIN</span>     
    <span class="kwrd">SELECT</span> [Name] <span class="kwrd">from</span> Person.StateProvince ;
<span class="kwrd">END</span>;
<span class="kwrd">GO</span>

/* Purpose: <span class="kwrd">To</span> <span class="kwrd">get</span> <span class="kwrd">all</span> <span class="kwrd">state</span> <span class="kwrd">in</span> <span class="kwrd">specific</span> country */ 
<span class="kwrd">IF</span>  <span class="kwrd">EXISTS</span> (<span class="kwrd">SELECT</span> * <span class="kwrd">FROM</span> sys.objects <span class="kwrd">WHERE</span> 
object_id = OBJECT_ID(N<span class="str">'[Person].[usp_GetStatesInCountry]'</span>) <span class="kwrd">AND</span> type <span class="kwrd">in</span> (N<span class="str">'P'</span>, N<span class="str">'PC'</span>))
<span class="kwrd">DROP</span> <span class="kwrd">PROCEDURE</span> [Person].[usp_GetStatesInCountry]
<span class="kwrd">GO</span>

<span class="kwrd">CREATE</span> <span class="kwrd">PROCEDURE</span> [Person].[usp_GetStatesInCountry]
    @CountryCode <span class="kwrd">nchar</span>(3)  
<span class="kwrd">AS</span>
<span class="kwrd">BEGIN</span>     
    <span class="kwrd">SELECT</span> [Name] <span class="kwrd">FROM</span> Person.StateProvince <span class="kwrd">WHERE</span> 
    CountryRegionCode=@CountryCode;
<span class="kwrd">END</span>;

GO</pre>
                                                As DB developers, we should test our code after we implemented them. For example, we can use the following test cases to verify our logic,
                                                <ul>
                                                    <li>1. The count of states in USA should be 53, including Guam, District of Columbia, Puerto Rico. </li>
                                                    <li>2. Every state in the USA also should be in usp_GetAllStates. </li>
                                                </ul>
                                                Actually, we can design more test cases. But in this example, we only use these two cases for demonstrating how to use AnyDbTest.
                                                <br />
                                                <br />
                                                Authoring test cases for AnyDbTest includes the following steps,
                                                <ul>
                                                    <li>1. Create one blank test case XML file; </li>
                                                    <li>2. Declare database connection; </li>
                                                    <li>3. Declare procedure/SQL statement definition; </li>
                                                    <li>4. Write unit test/performance test. </li>
                                                </ul>
                                                <strong>Step 1,</strong> we can use any text editor, even NotePad, to create a blank test file. But we recommend you strongly to use those advanced XML editors with code completion assistance. e.g. <a href="http://www.wmhelp.com/download.htm">XmlPad</a> is a free and powerful XML editor. These XML editors will be helpful to author test file from scratch.  
                                                <br />
                                                <br />
                                                One XML schema file namely <strong>TestFileSchema2.xsd</strong> has been packed in AnyDbTest distribution package. Suppose that this schema file is stored in the root folder of C drive. Now we have one blank test file displayed below,
                                                <br />
<!-- code formatted by http://manoli.net/csharpformat/ -->
<pre class="csharpcode">
<span class="kwrd">&lt;?</span><span class="html">xml</span> <span class="attr">version</span><span class="kwrd">="1.0"</span> <span class="attr">encoding</span><span class="kwrd">="utf-8"</span>?<span
      class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">dbTestFixture</span>
      <span class="attr">xmlns:xsi</span><span class="kwrd">="http://www.w3.org/2001/XMLSchema-instance"</span>
      <span class="attr">xsi:noNamespaceSchemaLocation</span><span class="kwrd">="file:/C:/TestFileSchema2.xsd"</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">globalSetting</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">globalSetting</span><span class="kwrd">&gt;</span>

  <span class="kwrd">&lt;</span><span class="html">procDeclarations</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">procDeclarations</span><span class="kwrd">&gt;</span>

  <span class="kwrd">&lt;</span><span class="html">sqlDeclarations</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">sqlDeclarations</span><span class="kwrd">&gt;</span>
  
  <span class="kwrd">&lt;</span><span class="html">unitTestCases</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">unitTestCases</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">dbTestFixture</span><span class="kwrd">&gt;</span>
</pre>
                                                <strong>Step 2,</strong> we can use DbConnectionBuilder application to help us to create database connection, it is a GUI wizard. We can input the SQL Server location and database name and SQL Server user/password. Notice it also supports integrated Windows authentication for SQL Server, which is what we used in the screenshot below.
                                                <br />
                                                <br />
                                                <div align="center">
                                                    <img src="images/screenshots/small_DbConnectionBuilderSample.png" alt="bConnectionBuilder wizard" width="271" height="320" border="0" onclick="MM_preloadImages('images/screenshots/big_DbConnectionBuilderSample.png')" />
                                                </div>
                                                <br />
                                                The wizard will output one string. In our example, the result string is,
                                                <br />
<!-- code formatted by http://manoli.net/csharpformat/ -->
<pre class="csharpcode">
<span class="kwrd">&lt;</span><span class="html">dbConnection</span> <span class="attr">connectionName</span><span class="kwrd">=" "</span> 
     <span class="attr">connectionString</span><span class="kwrd">="Data Source=localhost\SQLEXPRESS; 
     Initial Catalog=AdventureWorks; Integrated Security=True;
     User ID=;Password="</span>    
     <span class="attr">providerName</span><span class="kwrd">="System.Data.SqlClient"</span> <span class="kwrd">/&gt;</span>
</pre>
                                                After that, copy the connection string above into globalSetting section of the test file, and give a name for this connection like db1. The globalSetting section now is,
<!-- code formatted by http://manoli.net/csharpformat/ -->
<pre class="csharpcode">
<span class="kwrd">&lt;</span><span class="html">globalSetting</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">dbConnection</span> <span class="attr">connectionName</span><span class="kwrd">="db1"</span>
  <span class="attr">connectionString</span><span class="kwrd">="Data Source=localhost\SQLEXPRESS; 
  Initial Catalog=AdventureWorks; Integrated Security=True; 
  User ID=;Password="</span>
  <span class="attr">providerName</span><span class="kwrd">="System.Data.SqlClient"</span> <span class="kwrd">/&gt;</span>
<span class="kwrd">&lt;/</span><span class="html">globalSetting</span><span class="kwrd">&gt;</span></pre>
                                                <strong>Step 3,</strong> now we need to tell AnyDbTest, what are our stored procedures, and where? With code completion of XML editor(like <a href="http://www.wmhelp.com/download.htm">
                                                    XmlPad</a>), actually, this process also is very easy. The procDeclarations section is as follows,
                                                <br />
<!-- code formatted by http://manoli.net/csharpformat/ -->
<pre class="csharpcode">
  <span class="kwrd">&lt;</span><span class="html">procDeclarations</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">procDeclaration</span> <span class="attr">alias</span><span class="kwrd">="proc_Get_state_in_country"</span> <span class="attr">dbConnection</span><span
      class="kwrd">="db1"</span>
    <span class="attr">name</span><span class="kwrd">="usp_GetStatesInCountry"</span> <span class="attr">namespace</span><span class="kwrd">="Person"</span><span class="kwrd">&gt;</span>
    <span class="kwrd">&lt;</span><span class="html">remark</span><span class="kwrd">&gt;</span>
      This is declaration for usp_GetStatesInCountry
    <span class="kwrd">&lt;/</span><span class="html">remark</span><span class="kwrd">&gt;</span>
    <span class="kwrd">&lt;</span><span class="html">arguments</span><span class="kwrd">&gt;</span>
      <span class="kwrd">&lt;</span><span class="html">argument</span> <span class="attr">name</span><span class="kwrd">="@CountryCode"</span> <span class="attr">direction</span><span class="kwrd">="Input"</span> 
                <span class="attr">type</span><span class="kwrd">="MSSQL_NCHAR"</span><span class="kwrd">/&gt;</span>
      <span class="kwrd">&lt;</span><span class="html">argument</span> <span class="attr">name</span><span class="kwrd">="@Return_Table"</span> <span class="attr">direction</span><span class="kwrd">="AnonymousOutput"</span> 
                <span class="attr">type</span><span class="kwrd">="MSSQL_RECORDSET"</span><span class="kwrd">/&gt;</span>
    <span class="kwrd">&lt;/</span><span class="html">arguments</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">procDeclaration</span><span class="kwrd">&gt;</span>

  <span class="kwrd">&lt;</span><span class="html">procDeclaration</span> <span class="attr">alias</span><span class="kwrd">="proc_Get_all_state"</span> <span class="attr">dbConnection</span><span
      class="kwrd">="db1"</span>
   <span class="attr">name</span><span class="kwrd">="usp_GetAllStates"</span> <span class="attr">namespace</span><span class="kwrd">="Person"</span><span class="kwrd">&gt;</span>
    <span class="kwrd">&lt;</span><span class="html">remark</span><span class="kwrd">&gt;</span>
      This is declaration for "[Person].[usp_GetAllStates]"
    <span class="kwrd">&lt;/</span><span class="html">remark</span><span class="kwrd">&gt;</span>
    <span class="kwrd">&lt;</span><span class="html">arguments</span><span class="kwrd">&gt;</span>
      <span class="kwrd">&lt;</span><span class="html">argument</span> <span class="attr">name</span><span class="kwrd">="@Return_Table"</span> <span class="attr">direction</span><span class="kwrd">="AnonymousOutput"</span> 
                <span class="attr">type</span><span class="kwrd">="MSSQL_RECORDSET"</span><span class="kwrd">/&gt;</span>
    <span class="kwrd">&lt;/</span><span class="html">arguments</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">procDeclaration</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">procDeclarations</span><span class="kwrd">&gt;</span>
</pre>
                                                Additionally, in sqlDeclarations section we add one SQL statement declaration for getting a constant number from SQL Server. It is used in this test file.
                                                <br />
<!-- code formatted by http://manoli.net/csharpformat/ -->
<pre class="csharpcode">
<span class="kwrd">&lt;</span><span class="html">sqlDeclarations</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">sqlDeclaration</span> <span class="attr">alias</span><span class="kwrd">="sql_get_const_number"</span> <span class="attr">dbConnection</span><span
      class="kwrd">="db1"</span><span class="kwrd">&gt;</span>
    <span class="kwrd">&lt;</span><span class="html">remark</span><span class="kwrd">&gt;</span>to get constant number from database server
    <span class="kwrd">&lt;/</span><span class="html">remark</span><span class="kwrd">&gt;</span>
    <span class="kwrd">&lt;</span><span class="html">sql</span><span class="kwrd">&gt;&lt;!</span>[CDATA[select @constant]]<span class="kwrd">&gt;&lt;/</span><span class="html">sql</span><span
        class="kwrd">&gt;</span>
    <span class="kwrd">&lt;</span><span class="html">arguments</span><span class="kwrd">&gt;</span>
      <span class="kwrd">&lt;</span><span class="html">argument</span> <span class="attr">name</span><span class="kwrd">="@constant"</span> <span class="attr">direction</span><span class="kwrd">="Input"</span> <span
          class="attr">type</span><span class="kwrd">="MSSQL_INT"</span><span class="kwrd">/&gt;</span>
      <span class="kwrd">&lt;</span><span class="html">argument</span> <span class="attr">name</span><span class="kwrd">="@result"</span> <span class="attr">direction</span><span class="kwrd">="Return"</span> <span
          class="attr">type</span><span class="kwrd">="MSSQL_INT"</span><span class="kwrd">/&gt;</span>
    <span class="kwrd">&lt;/</span><span class="html">arguments</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">sqlDeclaration</span><span class="kwrd">&gt;</span>
<span class="kwrd">&lt;/</span><span class="html">sqlDeclarations</span><span class="kwrd">&gt;</span>
</pre>
                                                <strong>Step 4.</strong> Now it is time to create our test cases. As mentioned above, we will create two unit test cases: the first case is to verify states amount of USA is 53; the second is to verify that every state of USA also should be in the usp_GetAllStates().
                                                <br />
                                                <br />
                                                One unit test case includes 3 mandatory parts, they are assertion type, targetResultset, referenceResultset. We will explain them one by one.
                                                <br />
                                                <br />
                                                Assertion type is to tell AnyDbTest how to judge if the test is successful. AnyDbTest contains the various standard assertions such as RecordCountEqual and IsSubsetOf and so on. Section targetResultset is our testing target; and section referenceResultset is our reference result set.
                                                
                                                <br />
                                                <br />
                                                For test case 1, we choose the <strong>RecordCountEqual</strong> as assertion type. In this case, targetResultset comes from proc_Get_state_in_country. proc_Get_state_in_country is statement alias for stored procedure usp_GetStatesInCountry. Let us assign "US" to the value of @CountryCode input-type argument. The referenceResultset is constant number 53.
                                                <br />
                                                <br />
                                                Finally, the unit test case section is as follows,
                                                <br />
<!-- code formatted by http://manoli.net/csharpformat/ -->
<pre class="csharpcode">
<span class="kwrd">&lt;</span><span class="html">unitTestCase</span> <span class="attr">testCaseName</span><span class="kwrd">="UT_USA_states_count"</span> 
              <span class="attr">assertion</span><span class="kwrd">="RecordCountEqual"</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">testCaseRemark</span><span class="kwrd">&gt;</span>to test how many states in USA
  <span class="kwrd">&lt;/</span><span class="html">testCaseRemark</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">targetResultset</span> <span class="attr">statementAlias</span><span class="kwrd">="proc_Get_state_in_country"</span> 
                   <span class="attr">outputArgument</span><span class="kwrd">="@return_table"</span> <span class="kwrd">&gt;</span>
    <span class="kwrd">&lt;</span><span class="html">inputArguments</span><span class="kwrd">&gt;</span>
      <span class="kwrd">&lt;</span><span class="html">argument</span> <span class="attr">name</span><span class="kwrd">="@CountryCode"</span> <span class="attr">value</span><span class="kwrd">="US"</span><span
          class="kwrd">/&gt;</span>
    <span class="kwrd">&lt;/</span><span class="html">inputArguments</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">targetResultset</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">referenceResultset</span> <span class="attr">statementAlias</span><span class="kwrd">="sql_get_const_number"</span> 
                      <span class="attr">outputArgument</span><span class="kwrd">="@result"</span><span class="kwrd">&gt;</span>
    <span class="kwrd">&lt;</span><span class="html">inputArguments</span><span class="kwrd">&gt;</span>
      <span class="kwrd">&lt;</span><span class="html">argument</span> <span class="attr">name</span><span class="kwrd">="@constant"</span> <span class="attr">value</span><span class="kwrd">="53"</span><span
          class="kwrd">/&gt;</span>
    <span class="kwrd">&lt;/</span><span class="html">inputArguments</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">referenceResultset</span><span class="kwrd">&gt;</span>
<span class="kwrd">&lt;/</span><span class="html">unitTestCase</span><span class="kwrd">&gt;</span>
</pre>
                                                For test case 2, In fact, it is to judge one result set is subset of another result set. We choose another standard assertion type <strong>IsSubsetOf</strong> from available types. The entire unit test section is as follows,
                                                <br />
<!-- code formatted by http://manoli.net/csharpformat/ -->
<pre class="csharpcode">
<span class="kwrd">&lt;</span><span class="html">unitTestCase</span> <span class="attr">testCaseName</span><span class="kwrd">="UT_USA_States_Is_subset_of"</span> 
              <span class="attr">assertion</span><span class="kwrd">="IsSubsetOf"</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">testCaseRemark</span><span class="kwrd">&gt;</span>to judge states in USA appear in 
  result set of usp_GetAllStates<span class="kwrd">&lt;/</span><span class="html">testCaseRemark</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">targetResultset</span> <span class="attr">statementAlias</span><span class="kwrd">="proc_Get_state_in_country"</span> 
                   <span class="attr">outputArgument</span><span class="kwrd">="return_table"</span><span class="kwrd">&gt;</span>
    <span class="kwrd">&lt;</span><span class="html">inputArguments</span><span class="kwrd">&gt;</span>
      <span class="kwrd">&lt;</span><span class="html">argument</span> <span class="attr">name</span><span class="kwrd">="@CountryCode"</span> <span class="attr">value</span><span class="kwrd">="US"</span><span
          class="kwrd">/&gt;</span>
    <span class="kwrd">&lt;/</span><span class="html">inputArguments</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">targetResultset</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;</span><span class="html">referenceResultset</span> <span class="attr">statementAlias</span><span class="kwrd">="proc_Get_all_state"</span> 
                      <span class="attr">outputArgument</span><span class="kwrd">="return_table"</span><span class="kwrd">&gt;</span>
  <span class="kwrd">&lt;/</span><span class="html">referenceResultset</span><span class="kwrd">&gt;</span>
<span class="kwrd">&lt;/</span><span class="html">unitTestCase</span><span class="kwrd">&gt;</span>
</pre>
                                                It is time to launch AnyDbTest to run our test file. Launch the AnyDbTest, and load the test case file. Then click the button ' Run case file '. You will see the familiar Red-Green
                                                Light icon just like other unit testing tool.
                                                <br />
                                                <br />
                                                <div align="center">
                                                    <img src="images/screenshots/small_UnitTest.png" alt="AnyDbTest Gui Runner" width="449" height="312" border="0" onclick="MM_preloadImages('images/screenshots/big_AnyDbTest_GuiRunner.png')" />
                                                </div>
                                                <br />
                                                The whole process is easy, isn&#146;t it?
                                                <br />
                                                <br />
                                            </p>
                                                        
                                                        
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td height="37">
                                                        <span class="productButtons"><a href="product.html">
                                                            <img src="images/layout/more-button.jpg" alt="More Info" border="0" height="26" width="101">&nbsp; </a>&nbsp;&nbsp;&nbsp; <a href="download.html#DownloadAnyDbTest">
                                                                <img src="images/layout/download-button.jpg" alt="Download" border="0" height="26" width="101">&nbsp; </a>&nbsp;&nbsp;&nbsp; <a href="purchase.html#OrderSection">
                                                                    <img src="images/layout/purchase-button.jpg" alt="Purchase Now" border="0" height="26" width="101">&nbsp; </a></span>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td colspan="2">
                                                        <hr class="productSeparator">
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                        <br />
                                        <br />
                                        <!-- InstanceEndEditable -->
                                    </div>
                                </td>
                                <td background="images/layout/right-column-bg.gif" valign="top" width="226">
                                    <table border="0" cellpadding="0" cellspacing="0" width="100%">
                                        <tbody>
                                            <tr>
                                                <td class="rightColumn">
                                                    &nbsp;
                                                </td>
                                            </tr>
                                            <tr>
                                                <td valign="top">
                                                    <div class="RightColumnPadding">
                                                        <!-- InstanceBeginEditable name="RightRegion" -->
                                                                                                                <table border="0" cellpadding="0" cellspacing="0" width="96%">
                                                            <tbody>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="TutorialAboutUnitTesting.html">About Unit Testing</a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="TutorialQuickStart.html">Quick Start</a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="TutorialCheatSheet.html">Cheat Sheet</a>
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="TutorialReference.html">Reference</a>
                                                                    </td>
                                                                </tr>
																<!--
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="TutorialTroubleshooting.html">Troubleshooting </a>
                                                                    </td>
                                                                </tr>
							-->									
                                                                <tr>
                                                                    <td colspan="3">
                                                                        &nbsp;
                                                                    </td>
                                                                </tr>
                                                            </tbody>
                                                        </table>

                                                        <script type="text/javascript">
                                                        var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
                                                        document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
                                                        </script>
                                                        <script type="text/javascript">
                                                        try {
                                                        var pageTracker = _gat._getTracker("UA-8398936-1");
                                                        pageTracker._trackPageview();
                                                        } catch(err) {}</script>

                                                        <!-- InstanceEndEditable -->
                                                        <br />
                                                        <div align="center">

                                                            <script src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/translatemypage.xml&up_source_language=en&w=160&h=60&title=&border=&output=js"></script>

                                                        </div>
                                                    </div>
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </td>
                                <td width="9">
                                    &nbsp;
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </td>
            </tr>
            <tr>
                <td height="46" colspan="3" valign="middle" background="images/layout/site-border-bottom-full.gif" onfocus="MM_preloadImages('images/layout/site-border-bottom-full.gif')">
                    <table width="362" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                            <td width="12" class="menuBottom">
                                &nbsp;
                            </td>
                            <td width="350" class="BottomLinks">
                                &nbsp;&nbsp; <a href="index.html">About AnyDbTest</a>&nbsp;&nbsp;|&nbsp;&nbsp; <a href="license.html">Terms of Usage</a>&nbsp;&nbsp;|&nbsp;&nbsp; <a href="privacy.html">Privacy Policy</a>&nbsp;&nbsp;|&nbsp;&nbsp;
                                <!--
        		<a href="customers.html">Our Clients</a>
                -->
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td colspan="3" class="copyrightNotice">
                    &nbsp;
                </td>
            </tr>
            <tr>
                <td colspan="3" class="copyrightNotice">
                    <span class="copyrightNotice">Copyright &copy; 2008 - 2010 AnyDbTest Technology. All rights reserved.</span>
                </td>
            </tr>
            <tr>
                <td colspan="3" class="copyrightNoticeProducts">
                    <span class="copyrightNoticeProducts">AnyDbTest are trademarks or registered trademarks of AnyDbTest Technology.</span>
                </td>
            </tr>
        </tbody>
    </table>
    <br />
    <map name="Map" id="Map">
        <area shape="rect" coords="22,19,257,80" href="index.html" alt="AnyDbTest">
    </map>
    <!-- InstanceEnd -->
</body>
</html>
